Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerCorrespondenceReceivedDate (PK) | The date and time that a CUSTOMER's letter, fax, e-mail, or phone call is taken or received at a retail store or other facility. | DC_CRSP_CT_RCV | DateCalendar | date | |
CustomerID (FK)(PK) | A unique system assigned identifier for the Customer. | ID_CT | Identity | integer | Customer(PA_CT) |
SendDate | The date and time that a CUSTOMER's letter, fax, e-mail, or phone call was sent by the customer. | DC_CRSP_CT_SND | DateCalendar | date | |
CreatedDate | The date and time that a CUSTOMER's letter, fax, or e-mail was created. | DC_CRSP_CT_CRT | DateCalendar | date | |
SummaryDescription | A brief interpretation summarizing the main points of the correspondence. | DE_CRSP_CT_SMY | DescriptionNarrative | varchar(4000) | |
ChannelID (FK) | Token Identifier for a channel instance | ID_CHNL | Identity | integer | Channel(CO_CHNL) |